Skip to main content

Create Record

Create Record Overview​

The Create Record feature allows users to add a new row of information into a pre-established database table. It supports selecting the data source, schema, table, and specific columns with values for insertion.

Interface Components​

Name​

  • Input field to specify the record or operation name.

Select Source​

  • Dropdown to choose the data source from available connections.

Select Schema​

  • Dropdown to select the schema within the data source.

Select Table​

  • Dropdown to pick the table for the new record.

Select Column​

  • Allows selection of columns within the table.
  • Input field for values to be inserted.
  • Supports formula/expression entry via an fx button.
  • Add (+) and delete buttons to manage multiple column-value pairs.

Actions​

  • OK Button: Confirms and submits the record creation.
  • Cancel Button: Cancels and closes the dialog.

Usage Instructions​

  1. Enter a name for the record creation task.
  2. Select the data source, schema, and table.
  3. Specify the columns and their corresponding values for the new record.
  4. Use the formula button if needed to input expressions.
  5. Add or remove columns as required.
  6. Click OK to create the record or Cancel to abort.

This feature offers a flexible interface for detailed record insertion into database tables.